You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'cube_blog_list[i]['id'] ''' at line 1
SELECT COUNT(*) as `count` FROM `cube_product`  WHERE `cube_product`.`store_id`= '1686' AND `cube_product`.`item_id`= '' cube_blog_list[i]['id'] ''  
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'cube_blog_list[i]['id'] ''' at line 4
SELECT `cube_product`.`item_id`, `cube_product`.`upload_name`, `cube_product`.`new_ver`, `cube_product`.`event_json`, `cube_product`.`warehouse_status`, `cube_product`.`tag_json`, `cube_product`.`seo_description`, `cube_product`.`get_show_price`, `cube_product`.`get_show_each_stock`, `cube_product`.`get_show_stock_json`, `cube_product`.`current_title_id`, `cube_product`.`oversale`, `cube_product`.`super_option_id`, `cube_product`.`super_option_val`, `cube_product`.`super_option_json`, `cube_product`.`package_val`, `cube_product`.`package_items`, `cube_product`.`package_edit_date`, `cube_product`.`fb_img`, `cube_product`.`pickup_id`, `cube_product`.`qc_price`, `cube_product`.`qc_val`, `cube_product`.`qc_sale_limit`, `cube_product`.`qc_payway`, `cube_product`.`qc_shipway`, `cube_product`.`qc_pay_way`, `cube_product`.`qc_ship_way`, `cube_product`.`qc_ship_pay`, `cube_product`.`qc_notes`, `cube_product`.`pt_get`, `cube_product`.`pt_use`, `cube_product`.`price_update`, `cube_product`.`soldout`, `cube_product`.`btn_name`, `cube_product`.`btn_name_en`, `cube_product`.`item_name_en`, `cube_product`.`item_name_show`, `cube_product`.`item_name_show_en`, `cube_product`.`item_contents_en`, `cube_product`.`count_view`, `cube_product`.`show_type`, `cube_product`.`index_id`, `cube_product`.`store_id`, `cube_product`.`item_type`, `cube_product`.`saledline`, `cube_product`.`arr_date`, `cube_product`.`salestart`, `cube_product`.`saleend`, `cube_product`.`main_photo`, `cube_product`.`photos_json`, `cube_product`.`stock_text`, `cube_product`.`item_name`, `cube_product`.`item_exp`, `cube_product`.`item_exp_notice`, `cube_product`.`item_no`, `cube_product`.`item_sku2`, `cube_product`.`item_code`, `cube_product`.`item_o_price`, `cube_product`.`nowprice`, `cube_product`.`show_nowprice`, `cube_product`.`member_price`, `cube_product`.`show_label`, `cube_product`.`label_json`, `cube_product`.`dcdline`, `cube_product`.`dcstart_type`, `cube_product`.`dcend_type`, `cube_product`.`dcstart`, `cube_product`.`dcend`, `cube_product`.`cost`, `cube_product`.`supplier`, `cube_product`.`hideprice`, `cube_product`.`cart_tip`, `cube_product`.`cart_tip_en`, `cube_product`.`item_price`, `cube_product`.`item_price1`, `cube_product`.`shop_price`, `cube_product`.`shop_price1`, `cube_product`.`shop_price2`, `cube_product`.`item_contents`, `cube_product`.`prod_code`, `cube_product`.`item_style`, `cube_product`.`lt_item_style`, `cube_product`.`ppc_json`, `cube_product`.`storage`, `cube_product`.`item_category`, `cube_product`.`item_shipping`, `cube_product`.`item_label`, `cube_product`.`limit_sale`, `cube_product`.`min_sale`, `cube_product`.`remark_link`, `cube_product`.`remark_text`, `cube_product`.`status`, `cube_product`.`super_price`, `cube_product`.`super_shopprice`, `cube_product`.`super_shopprice1`, `cube_product`.`super_shopprice2`, `cube_product`.`superlink_text`, `cube_product`.`superlink_text_en`, `cube_product`.`set_remark_val`, `cube_product`.`set_remark_title`, `cube_product`.`set_remark_title_en`, `cube_product`.`set_img_val`, `cube_product`.`set_img_title`, `cube_product`.`set_img_title_en`, `cube_product`.`ppc`, `cube_product`.`sub_item_json`, `cube_product`.`set_sub_item_status`, `cube_product`.`super_wholesale_price`, `cube_product`.`up_date` 
 FROM `cube_product` 
  
 WHERE `cube_product`.`store_id`= '1686' AND `cube_product`.`item_id`= '' cube_blog_list[i]['id'] ''  
  
  
 
Whoops! There was an error.
Error
Call to a member function fetch_assoc() on boolean Error thrown with message "Call to a member function fetch_assoc() on boolean" Stacktrace: #2 Error in /var/www/cubemo/sdba/sdba.php:132 #1 Sdba:get in /var/www/cubemo/app.store_v4/seo.php:60 #0 require_once in /var/www/cubemo/app.store_v4/index.php:209
Stack frames (3)
2
Error
/
var
/
www
/
cubemo
/
sdba
/
sdba.php
132
1
Sdba
get
/
var
/
www
/
cubemo
/
app.store_v4
/
seo.php
60
0
require_once
/
var
/
www
/
cubemo
/
app.store_v4
/
index.php
209
/
var
/
www
/
cubemo
/
sdba
/
sdba.php
    }
    public function get($limit = 0, $start = 0)
    {
        $this->get_table_info($this->table, $this->table);
        $join = $this->_build_join();
        $select = $this->_build_select();
        $from = $this->_build_from();
        $where = $this->_build_where();
        $group = $this->_build_group();
        $order = $this->_build_order();
        $limit = $this->_build_limit($limit, $start);
        $output = array();
        $this->was_set = true;
        
        $q = "SELECT {$this->distinct}{$select} \r\n FROM {$from} \r\n {$join} \r\n {$where} \r\n {$group} \r\n {$order} \r\n {$limit}";
        $result = $this->db->query($q, MYSQLI_USE_RESULT);
        
        if ($this->db->error)
            $this->error($this->db->error, $q);
        while ($row = $result->fetch_assoc())
        {
            $output[] = $row;
        }
        $result->free();
        //print_r($output);
        return $output;
    }
    public function get_one()
    {
        $this->get_table_info($this->table, $this->table);
        $join = $this->_build_join();
        $select = $this->_build_select();
        $from = $this->_build_from();
        $where = $this->_build_where();
        $group = $this->_build_group();
        $order = $this->_build_order();
        $output = array();
        $this->was_set = true;
        $q = "SELECT {$this->distinct}{$select} FROM {$from} {$join} {$where} {$group} {$order} LIMIT 1";
        $result = $this->db->query($q, MYSQLI_USE_RESULT);
/
var
/
www
/
cubemo
/
app.store_v4
/
seo.php
//     $google_reCAPTCHA=$cube_stores_list[0]['google_reCAPTCHA'];
// }
// else{
//     $google_reCAPTCHA='6Lcgqx0TAAAAAOHvyOg5BY6KJilchnZHHp4pAs4z';
// }
$set_title = $set_store_name = $cube_stores_list[0]['store_showname'.$clang];
$set_description = $cube_stores_list[0]['store_description'];
$set_keywords = $cube_stores_list[0]['store_keywords'];
$set_image = $set_store_image = 'https://images.cube.mo/store_logo/'.$cube_stores_list[0]['storelogo']; 
$storeico = 'https://images.cube.mo/store_logo/'.$cube_stores_list[0]['storeico'].'?tr=h-192,w-192';
$meta_url = 'https://'.$domain;
$json_ld = '';
# Item Page
if (isset($_GET['page'])&&($_GET['page'] = 'item')&&(isset($_GET['id']))){
    $store_id=$cube_stores_list[0]['id'];
    $product = Sdba::table('cube_product');
    $product->where('store_id', $store_id );
    $product->and_where('item_id', $_GET['id']);
    $total_product = $product->total();
    $product_list = $product->get(); 
    if( $total_product == 1 ){
        if ($product_list[0]['fb_img'] != ''){
            $set_image='https://images.cube.mo/items/'.$product_list[0]['fb_img'];
        }
        else{
            $set_image='https://images.cube.mo/items/'.$product_list[0]['main_photo'];
        }
    
        
        $set_title=$product_list[0]['item_name'];
        
        $set_item_description = '';
        if ($product_list[0]['seo_description'] != ''){
            $set_description = $set_item_description = $product_list[0]['seo_description'];
        }
        
        if ($product_list[0]['tag_json'] != ''){
            $set_keywords =  str_replace("#",",",$product_list[0]['tag_json']);
        }
        
/
var
/
www
/
cubemo
/
app.store_v4
/
index.php
    }
    
    
    
    
    @media only screen and (max-width: 1140px) {
        .header1625{height: 400px !important; padding-bottom: 6rem !important; padding-top: 8rem !important; }
        .swiper-slide1625{width: 100% !important; height:400px !important;}
        .bh1{font-size: 38px;}
        .btn1625{border: 1px solid #fff;  padding: 8px 28px 8px;  font-size: 12px; margin-top:30px;}
        .h1625{    font-size: 38px;}
        .cardbody1625{padding-top: 8rem !important;padding-left: 0.5rem !important;padding-right: 0.5rem !important;padding-bottom: 5rem !important;}
        .bgimg{background-repeat: no-repeat !important; background-position: center!important;background-size: cover;}
        .btnp1625{text-align: center;}
    }
    <?php } ?> 
   
    </style>
    
    <?php require_once('seo.php'); ?>
</head>

<body class=" " data-page="index">
    
    <div class="container-fluid h-100 pageloader">
        <div class="row h-100">
            <div class="col-12 align-self-center">
                <figure class="  mb-4 mx-auto">
                    <img src="" class="storelogo" style="max-height:100px; max-width:200px; " alt=""  fill="#000000">
                </figure>
                 
                <p class="text-store_color text-mute"></p>
                <br>
                <div class="spinner-border " role="status">
                    <span class="sr-only">Loading...</span>
                </div>
            </div>
        </div> 
    </div>
 

Environment & details:

Key Value
page item
id ' cube_blog_list[i]['id'] '
empty
empty
empty
Key Value
_token 8c5bc92ca79e7e632cfa56356ec99e37
clang
Key Value
REDIRECT_UNIQUE_ID Zjvl63qgepCT2dM34BfbXgAAAA4
REDIRECT_SCRIPT_URL /blog/'+cube_blog_list[i]['id']+'
REDIRECT_SCRIPT_URI https://mcschooluniform.com/blog/'+cube_blog_list[i]['id']+'
REDIRECT_HTTPS on
REDIRECT_SSL_TLS_SNI mcschooluniform.com
REDIRECT_STATUS 200
UNIQUE_ID Zjvl63qgepCT2dM34BfbXgAAAA4
SCRIPT_URL /blog/'+cube_blog_list[i]['id']+'
SCRIPT_URI https://mcschooluniform.com/blog/'+cube_blog_list[i]['id']+'
HTTPS on
SSL_TLS_SNI mcschooluniform.com
HTTP_ACCEPT */*
HTTP_USER_AGENT Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_HOST mcschooluniform.com
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
SERVER_SIGNATURE
SERVER_SOFTWARE Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.2.34
SERVER_NAME mcschooluniform.com
SERVER_ADDR 10.0.0.33
SERVER_PORT 443
REMOTE_ADDR 18.218.38.125
DOCUMENT_ROOT /var/www/cubemo/app.store_v4
REQUEST_SCHEME https
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/cubemo/app.store_v4
SERVER_ADMIN root@localhost
SCRIPT_FILENAME /var/www/cubemo/app.store_v4/index.php
REMOTE_PORT 62427
REDIRECT_QUERY_STRING page=blog&id='+cube_blog_list[i]['id']+'
REDIRECT_URL /blog/'+cube_blog_list[i]['id']+'
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING page=blog&id='+cube_blog_list[i]['id']+'
REQUEST_URI /blog/'+cube_blog_list[i]['id']+'
SCRIPT_NAME /index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1715201515.562
REQUEST_TIME 1715201515
empty
0. Whoops\Handler\PrettyPageHandler